.png)
Proficient in utilizing Microsoft Excel, SQL, Python, and Power BI to facilitate data-driven decision-making. A dedicated and ambitious individual holding an MBA and a B.Tech in Mechanical Engineering from Aligarh Muslim University, as well as a Data Science course completion from AlmaBetter. Actively pursuing a role as a Data Analyst.
Jainya
May 2024 - Present
Lucknow
Lucknow
- Developed tables for employee details and created forms for tracking employee.Constructed tables from website backlink records and automated the process using Excel VBA and Data Validation.
- Designed a comprehensive dashboard to monitor website backlinks, incorporating key performance indicators (KPIs) and work metrics.
Almabetter
Jan 2023 - Present
Bengaluru
Bengaluru
- Acquired skills in feature engineering, exploratory data analysis (EDA), and data visualization. Gained hands-on experience with tools like Power BI, Tableau and Scikit Learn.
- Participated in projects including Hotel Bookings Analysis EDA, Customer Segmentation, Mobile Price Range Prediction.
- Developed proficiency in Python programming, SQL, Tableau, Excel, and Power BI.
Jazaa Business
Aug 2022- Oct 2022
New Delhi
New Delhi
- Role of acquiring data and meticulously organized spreadsheets to discern patterns, subsequently generating forecasts for revenue, profitability, and expenses.
- Designing of dashboard and organizing data using advanced excel functions
Hotel Booking Analysis
Google Colab
July 2023 – Aug 2023
AlmaBetter Verified
AlmaBetter Verified
- Performed comprehensive exploratory data analysis on a Hotel Bookings dataset consisting of 32 columns and 119,000 rows.
- Guests exhibited a preference for staying up to 4 days, with a notable inclination towards Resort Hotels for extended stays and City Hotels for shorter durations.
Manufacturing Efficiency
PowerBI
July 2023 – Aug 2023
AlmaBetter Verified
AlmaBetter Verified
- Created Interactive Power BI dashboards from the manufacturing Industry.
- Created different charts and visuals to identify trends and insights that could streamline manufacturing processes, optimize resource allocation, and enhance employee productivity.
- Conducted meticulous data cleansing, robust data modeling, and the strategic application of DAX for sophisticated analytics.
- Establish the relationship between production costs and output, analyzing employee performance across different departments
Financial Insights
tableau
July 2023 – Aug 2023
AlmaBetter Verified
AlmaBetter Verified
- Created an interactive dashboard to represent Financial Insights and observation through various charts and tables using financial data representing account type, transactions, country and loan.
- Generated many insights like impact of credit rating on interest rate, categorizes groups for safety level for loan, created future trends.
COVID-19 Dynamics
Excel
July 2023 – Aug 2023
AlmaBetter Verified
AlmaBetter Verified
- Using Excel, designed the dashboard for visual storytelling, trend analysis, and strategic planning, enabling a data-driven approach. Applied Advanced Excel Functions such as vlookup, xlookup and used concept such array indexing and utilize pivot tables for aggregation.
- Analyzes the effects of vaccination, positive case trends, death rate and recovery rate in different states and timeline.